Search Results for: "Kryptek"

Total Time	Avg Time	Count	Template
141 ms	141 ms	1	E:\inetpub\wwwroot\search.cfm
15 ms	15 ms	1	C:/inetpub/wwwroot/includes/dropship.cfm
3 ms	3 ms	1	E:/inetpub/wwwroot/Application.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/includes/metatags.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/includes/newheader.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/includes/security/block_access.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/includes/security/sql_injection.cfm
1 ms	1 ms	1	E:/inetpub/wwwroot/search_sidenav.cfm
0 ms	0 ms	2	C:/inetpub/wwwroot/includes/brands.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/of3.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/library.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/pagethru.cfm
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
145 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='Kryptek' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 176063 then 1 
 when 206158 then 2 
 when 252455 then 3 
 when 192652 then 4 
 when 192368 then 5 
 when 209855 then 6 
 when 209754 then 7 
 when 193511 then 8 
 when 197855 then 9 
 when 192370 then 10 
 when 173461 then 11 
 when 193510 then 12 
 when 193512 then 13 
 when 137839 then 14 
 when 175816 then 15 
 when 170670 then 16 
 when 137843 then 17 
 when 161988 then 18 
 when 168601 then 19 
 when 154855 then 20 
 when 182319 then 21 
 when 175885 then 22 
 when 195703 then 23 
 when 157986 then 24 
 when 173455 then 25 
 when 220554 then 26 
 when 158175 then 27 
 when 215061 then 28 
 when 158069 then 29 
 when 155193 then 30 
 when 175422 then 31 
 when 170108 then 32 
 when 155196 then 33 
 when 195702 then 34 
 when 155194 then 35 
 when 175884 then 36 
 when 228172 then 37 
 when 170100 then 38 
 when 161989 then 39 
 when 175886 then 40 
 when 195499 then 41 
 when 228174 then 42 
 when 245294 then 43 
 when 252294 then 44 
 when 247755 then 45 
 when 292469 then 46 
 when 292467 then 47 
 when 157751 then 48 
 when 251921 then 49 
 when 165268 then 50 
 when 178734 then 51 
 when 165266 then 52 
 when 296912 then 53 
 when 178735 then 54 
 when 165267 then 55 
 when 165265 then 56 
 when 157750 then 57 
 when 188297 then 58 
 when 165269 then 59 
 when 296914 then 60 
 when 205171 then 61 
 when 296913 then 62 
 when 163820 then 63 
 when 165137 then 64 
 when 292468 then 65 
 when 147699 then 66 
 when 252447 then 67 
 when 268468 then 68 
 when 245301 then 69 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (176063,206158,252455,192652,192368,209855,209754,193511,197855,192370,173461,193510,193512,137839,175816,170670,137843,161988,168601,154855,182319,175885,195703,157986,173455,220554,158175,215061,158069,155193,175422,170108,155196,195702,155194,175884,228172,170100,161989,175886,195499,228174,245294,252294,247755,292469,292467,157751,251921,165268,178734,165266,296912,178735,165267,165265,157750,188297,165269,296914,205171,296913,163820,165137,292468,147699,252447,268468,245301)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'firearms'
 
  and ltrim(rtrim(lower(a.brand))) = 'winchester firearms'
 
	and a.of3='6.5 PRC'
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =247755 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=247755 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 247755 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 247755 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=247755  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=247755
												and status='A' 
												and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=USERNAME=; CUSTOMER_ID=; CT_U=2600; EMAIL=; FIRST_NAME=; LAST_NAME=; PASSWORD=; PRD_U=299142%2C762
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/Kryptek/brand/winchester-firearms/dept/firearms/of3/6.5%20prc
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/Kryptek/brand/winchester-firearms/dept/firearms/of3/6.5 prc
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=12678
cftoken=d8bb3f9899c63611-EA285D83-B05C-37AB-D3607FF7E607EF39
hitcount=1
lastvisit={ts '2024-05-20 15:11:26'}
timecreated={ts '2024-05-20 15:11:26'}
urltoken=CFID=12678&CFTOKEN=d8bb3f9899c63611-EA285D83-B05C-37AB-D3607FF7E607EF39

Cookie Variables:
CFID=12678
CFTOKEN=d8bb3f9899c63611-EA285D83-B05C-37AB-D3607FF7E607EF39
CT_U=2600
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=299142,762
USERNAME=

Form Fields:
KWORD=Kryptek
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=12678
cftoken=d8bb3f9899c63611-EA285D83-B05C-37AB-D3607FF7E607EF39
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_12678_d8bb3f9899c63611-EA285D83-B05C-37AB-D3607FF7E607EF39
strarray=Array (0)
urltoken=CFID=12678&CFTOKEN=d8bb3f9899c63611-EA285D83-B05C-37AB-D3607FF7E607EF39

URL Parameters:
CLEARANCE=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=winchester-firearms
dept=firearms
kword=Kryptek
of3=6.5 prc